2  ORCA Sample Management Database

2.1 Introduction

The admin screen of the ORCA Sample Management Database can only be accessed on-campus at https://orca.otago.nz/orca. This page offers an overview of all the samples contained in the Sample Database.

To enter sample information into the database the administration screen need to be entered. This screen can be accessed using the following https://orca.otago.nz/orca/admin

Figure 2.1: Introductory screen for the ORCA Sample Database

The view upon entering the admin screen can be seen in Figure 2.1

2.2 Adding Data to ORCA Sample Management Database

2.2.1 Inital Steps

You will need to check that some of the fundamental data for the samples you are entering int the database has already been entered e.g. principal scientist, coring platform, program etc. If this data is not in the in the database it will need to be enteed prior to entering the sample information.

For example, the if the Principals link in Figure 2.2 is selected, a list of all the Principal Investigators (PI) already in the system will open (See Figure 2.2 (a)). If the PI for the samples being entered is not on this list, they will need to be entered. Select the Add button in the top right corner of the screen (See Figure 2.2 (a)) and a data entry screen to enter the new PI will open (See Figure 2.2 (b)). Fill out the required information and select on Save to enter the data.

(a) The main window showing the PI’s in the system
(b) The window that appears after Add is selected in the main PI window. Details of additonal PI’s can be added here
Figure 2.2: The windows that appear when the a new PI is being added to the database

2.2.2 Enter Sample Data for samples that follow the ORCA naming convention

All sample sites will have data entered the Expedition, Site and Drop tables

2.2.2.1 Expedition

2.2.2.2 Site

All sites will require the Expedition to be selected from the drop-down, a 3 Letter Location Code e.g DUS shall be entered into the Location Code field and 3 digit Site Number e.g 001 shall be entered into the Identifier field (See Figure 2.3 (a)).

If the site is not a long core then click save at the bottom of the screen to save the data into the Site table

Figure 2.3 (a) indicates the fields that must be filled out if a long core similar to IODP cores, LOCH Hydraulic Piston Core or the Uwitec Corer, is being collected at the site, the Site Latitude and Longitude shall also be entered in Decimal Degrees. A Water Depth should also be entered into this table

(a) The site data that must be entered for all sites except long cores
(b) The site data required for long cores
Figure 2.3: Entering the Site data into the database